| Id |
Primary key the unique identification of a row in the table. |
| IdCreator |
Foreign key to the table: User Identifies the user that created the row. |
| CreatedDate |
Date when the case was registered in the database. |
| IdCaseType |
Foreign key to the table: CaseType |
| IdCaseState |
Foreign key to the table: CaseState |
| Title |
A short text describing the subject of the case. The text is presented to the user to identify the case in the application interface. |
| Summary |
A long text giving a summary the contents of the case. |
| IsPrinciple |
If true the case is of a principle character. |
| ClosedDate |
Date of today when the case is closed. |
| DiscardAtDate |
The date when the case can be discarded. When passed the case can be discarded. |
| IdCaseStatus |
Foreign key to the table: CaseStatus |
| IdCheckCode01 |
Foreign key to the table: Code Code that have the purpose of restricting the users access to only some cases and documents. The foreign key column references check codes. Only one instance of each check code type can be related to a document or case. |
| IdCheckCode02 |
Foreign key to the table: Code Code that have the purpose of restricting the users access to only some cases and documents. The foreign key column references check codes. Only one instance of each check code type can be related to a document or case. |
| IdDiscardCode |
Foreign key to the table: DiscardCode |
| IdPrimaryCode |
Foreign key to the table: Code Every case and document must be related to exactly one primary code (an instance of the primary code type), and only one code type can be the primary code type. The primary code on cases and documents are used to categorize them uniquely (as in the "save as" menu in the office client). |
| LogicIdentifier |
Contains a logical identifier of the case. This is the identifier presented to the user in the application interface. Often the id of the case is used. Often the id of the document is used but it could also be a string combined from several other fields. |
| OnLoanDate |
Date for lending the case to a person. |
| OnLoanTo |
Name of a person who has lend the case. |
| RemoteFiledDate |
Date for archiving in the remote file. |
| IsDeleted |
Indication of whether the row is logically deleted |
| IdDeletedRow |
Foreign key to the table: Deletedrow Reference to further information for the logically deleted row |
| SubjectCode |
A text containing headwords characterizing the case. |
| ProcessDuration |
Contains a textual description of the time taken to consider the case. |
| Reference |
Contains a textual reference to ex. an old system from where the data was converted to eDoc from |
| NeutralTitle |
A neutral title for the case that is used when the case is published |
| LogicIdentifierPrefix |
Fist part of the LogicIdentifier |
| LogicIdentifierSuffix |
Last part of the LogicIdentifier |